/**
 * This file is part of mycollab-services.
 *
 * mycollab-services is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * mycollab-services is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with mycollab-services.  If not, see <http://www.gnu.org/licenses/>.
 */
package com.esofthead.mycollab.module.crm.domain;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

@SuppressWarnings("ucd")
public class QuoteExample {
    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    protected String orderByClause;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    protected boolean distinct;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    protected List<Criteria> oredCriteria;

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    public QuoteExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    @SuppressWarnings("ucd")
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andSubjectIsNull() {
            addCriterion("subject is null");
            return (Criteria) this;
        }

        public Criteria andSubjectIsNotNull() {
            addCriterion("subject is not null");
            return (Criteria) this;
        }

        public Criteria andSubjectEqualTo(String value) {
            addCriterion("subject =", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectNotEqualTo(String value) {
            addCriterion("subject <>", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectGreaterThan(String value) {
            addCriterion("subject >", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectGreaterThanOrEqualTo(String value) {
            addCriterion("subject >=", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectLessThan(String value) {
            addCriterion("subject <", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectLessThanOrEqualTo(String value) {
            addCriterion("subject <=", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectLike(String value) {
            addCriterion("subject like", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectNotLike(String value) {
            addCriterion("subject not like", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectIn(List<String> values) {
            addCriterion("subject in", values, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectNotIn(List<String> values) {
            addCriterion("subject not in", values, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectBetween(String value1, String value2) {
            addCriterion("subject between", value1, value2, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectNotBetween(String value1, String value2) {
            addCriterion("subject not between", value1, value2, "subject");
            return (Criteria) this;
        }

        public Criteria andQuotestageIsNull() {
            addCriterion("quotestage is null");
            return (Criteria) this;
        }

        public Criteria andQuotestageIsNotNull() {
            addCriterion("quotestage is not null");
            return (Criteria) this;
        }

        public Criteria andQuotestageEqualTo(String value) {
            addCriterion("quotestage =", value, "quotestage");
            return (Criteria) this;
        }

        public Criteria andQuotestageNotEqualTo(String value) {
            addCriterion("quotestage <>", value, "quotestage");
            return (Criteria) this;
        }

        public Criteria andQuotestageGreaterThan(String value) {
            addCriterion("quotestage >", value, "quotestage");
            return (Criteria) this;
        }

        public Criteria andQuotestageGreaterThanOrEqualTo(String value) {
            addCriterion("quotestage >=", value, "quotestage");
            return (Criteria) this;
        }

        public Criteria andQuotestageLessThan(String value) {
            addCriterion("quotestage <", value, "quotestage");
            return (Criteria) this;
        }

        public Criteria andQuotestageLessThanOrEqualTo(String value) {
            addCriterion("quotestage <=", value, "quotestage");
            return (Criteria) this;
        }

        public Criteria andQuotestageLike(String value) {
            addCriterion("quotestage like", value, "quotestage");
            return (Criteria) this;
        }

        public Criteria andQuotestageNotLike(String value) {
            addCriterion("quotestage not like", value, "quotestage");
            return (Criteria) this;
        }

        public Criteria andQuotestageIn(List<String> values) {
            addCriterion("quotestage in", values, "quotestage");
            return (Criteria) this;
        }

        public Criteria andQuotestageNotIn(List<String> values) {
            addCriterion("quotestage not in", values, "quotestage");
            return (Criteria) this;
        }

        public Criteria andQuotestageBetween(String value1, String value2) {
            addCriterion("quotestage between", value1, value2, "quotestage");
            return (Criteria) this;
        }

        public Criteria andQuotestageNotBetween(String value1, String value2) {
            addCriterion("quotestage not between", value1, value2, "quotestage");
            return (Criteria) this;
        }

        public Criteria andOpportunityidIsNull() {
            addCriterion("opportunityid is null");
            return (Criteria) this;
        }

        public Criteria andOpportunityidIsNotNull() {
            addCriterion("opportunityid is not null");
            return (Criteria) this;
        }

        public Criteria andOpportunityidEqualTo(Integer value) {
            addCriterion("opportunityid =", value, "opportunityid");
            return (Criteria) this;
        }

        public Criteria andOpportunityidNotEqualTo(Integer value) {
            addCriterion("opportunityid <>", value, "opportunityid");
            return (Criteria) this;
        }

        public Criteria andOpportunityidGreaterThan(Integer value) {
            addCriterion("opportunityid >", value, "opportunityid");
            return (Criteria) this;
        }

        public Criteria andOpportunityidGreaterThanOrEqualTo(Integer value) {
            addCriterion("opportunityid >=", value, "opportunityid");
            return (Criteria) this;
        }

        public Criteria andOpportunityidLessThan(Integer value) {
            addCriterion("opportunityid <", value, "opportunityid");
            return (Criteria) this;
        }

        public Criteria andOpportunityidLessThanOrEqualTo(Integer value) {
            addCriterion("opportunityid <=", value, "opportunityid");
            return (Criteria) this;
        }

        public Criteria andOpportunityidIn(List<Integer> values) {
            addCriterion("opportunityid in", values, "opportunityid");
            return (Criteria) this;
        }

        public Criteria andOpportunityidNotIn(List<Integer> values) {
            addCriterion("opportunityid not in", values, "opportunityid");
            return (Criteria) this;
        }

        public Criteria andOpportunityidBetween(Integer value1, Integer value2) {
            addCriterion("opportunityid between", value1, value2, "opportunityid");
            return (Criteria) this;
        }

        public Criteria andOpportunityidNotBetween(Integer value1, Integer value2) {
            addCriterion("opportunityid not between", value1, value2, "opportunityid");
            return (Criteria) this;
        }

        public Criteria andValiduntilIsNull() {
            addCriterion("validuntil is null");
            return (Criteria) this;
        }

        public Criteria andValiduntilIsNotNull() {
            addCriterion("validuntil is not null");
            return (Criteria) this;
        }

        public Criteria andValiduntilEqualTo(Date value) {
            addCriterion("validuntil =", value, "validuntil");
            return (Criteria) this;
        }

        public Criteria andValiduntilNotEqualTo(Date value) {
            addCriterion("validuntil <>", value, "validuntil");
            return (Criteria) this;
        }

        public Criteria andValiduntilGreaterThan(Date value) {
            addCriterion("validuntil >", value, "validuntil");
            return (Criteria) this;
        }

        public Criteria andValiduntilGreaterThanOrEqualTo(Date value) {
            addCriterion("validuntil >=", value, "validuntil");
            return (Criteria) this;
        }

        public Criteria andValiduntilLessThan(Date value) {
            addCriterion("validuntil <", value, "validuntil");
            return (Criteria) this;
        }

        public Criteria andValiduntilLessThanOrEqualTo(Date value) {
            addCriterion("validuntil <=", value, "validuntil");
            return (Criteria) this;
        }

        public Criteria andValiduntilIn(List<Date> values) {
            addCriterion("validuntil in", values, "validuntil");
            return (Criteria) this;
        }

        public Criteria andValiduntilNotIn(List<Date> values) {
            addCriterion("validuntil not in", values, "validuntil");
            return (Criteria) this;
        }

        public Criteria andValiduntilBetween(Date value1, Date value2) {
            addCriterion("validuntil between", value1, value2, "validuntil");
            return (Criteria) this;
        }

        public Criteria andValiduntilNotBetween(Date value1, Date value2) {
            addCriterion("validuntil not between", value1, value2, "validuntil");
            return (Criteria) this;
        }

        public Criteria andShippingIsNull() {
            addCriterion("shipping is null");
            return (Criteria) this;
        }

        public Criteria andShippingIsNotNull() {
            addCriterion("shipping is not null");
            return (Criteria) this;
        }

        public Criteria andShippingEqualTo(String value) {
            addCriterion("shipping =", value, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingNotEqualTo(String value) {
            addCriterion("shipping <>", value, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingGreaterThan(String value) {
            addCriterion("shipping >", value, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingGreaterThanOrEqualTo(String value) {
            addCriterion("shipping >=", value, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingLessThan(String value) {
            addCriterion("shipping <", value, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingLessThanOrEqualTo(String value) {
            addCriterion("shipping <=", value, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingLike(String value) {
            addCriterion("shipping like", value, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingNotLike(String value) {
            addCriterion("shipping not like", value, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingIn(List<String> values) {
            addCriterion("shipping in", values, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingNotIn(List<String> values) {
            addCriterion("shipping not in", values, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingBetween(String value1, String value2) {
            addCriterion("shipping between", value1, value2, "shipping");
            return (Criteria) this;
        }

        public Criteria andShippingNotBetween(String value1, String value2) {
            addCriterion("shipping not between", value1, value2, "shipping");
            return (Criteria) this;
        }

        public Criteria andBillaccountIsNull() {
            addCriterion("billaccount is null");
            return (Criteria) this;
        }

        public Criteria andBillaccountIsNotNull() {
            addCriterion("billaccount is not null");
            return (Criteria) this;
        }

        public Criteria andBillaccountEqualTo(Integer value) {
            addCriterion("billaccount =", value, "billaccount");
            return (Criteria) this;
        }

        public Criteria andBillaccountNotEqualTo(Integer value) {
            addCriterion("billaccount <>", value, "billaccount");
            return (Criteria) this;
        }

        public Criteria andBillaccountGreaterThan(Integer value) {
            addCriterion("billaccount >", value, "billaccount");
            return (Criteria) this;
        }

        public Criteria andBillaccountGreaterThanOrEqualTo(Integer value) {
            addCriterion("billaccount >=", value, "billaccount");
            return (Criteria) this;
        }

        public Criteria andBillaccountLessThan(Integer value) {
            addCriterion("billaccount <", value, "billaccount");
            return (Criteria) this;
        }

        public Criteria andBillaccountLessThanOrEqualTo(Integer value) {
            addCriterion("billaccount <=", value, "billaccount");
            return (Criteria) this;
        }

        public Criteria andBillaccountIn(List<Integer> values) {
            addCriterion("billaccount in", values, "billaccount");
            return (Criteria) this;
        }

        public Criteria andBillaccountNotIn(List<Integer> values) {
            addCriterion("billaccount not in", values, "billaccount");
            return (Criteria) this;
        }

        public Criteria andBillaccountBetween(Integer value1, Integer value2) {
            addCriterion("billaccount between", value1, value2, "billaccount");
            return (Criteria) this;
        }

        public Criteria andBillaccountNotBetween(Integer value1, Integer value2) {
            addCriterion("billaccount not between", value1, value2, "billaccount");
            return (Criteria) this;
        }

        public Criteria andBillcontactIsNull() {
            addCriterion("billcontact is null");
            return (Criteria) this;
        }

        public Criteria andBillcontactIsNotNull() {
            addCriterion("billcontact is not null");
            return (Criteria) this;
        }

        public Criteria andBillcontactEqualTo(Integer value) {
            addCriterion("billcontact =", value, "billcontact");
            return (Criteria) this;
        }

        public Criteria andBillcontactNotEqualTo(Integer value) {
            addCriterion("billcontact <>", value, "billcontact");
            return (Criteria) this;
        }

        public Criteria andBillcontactGreaterThan(Integer value) {
            addCriterion("billcontact >", value, "billcontact");
            return (Criteria) this;
        }

        public Criteria andBillcontactGreaterThanOrEqualTo(Integer value) {
            addCriterion("billcontact >=", value, "billcontact");
            return (Criteria) this;
        }

        public Criteria andBillcontactLessThan(Integer value) {
            addCriterion("billcontact <", value, "billcontact");
            return (Criteria) this;
        }

        public Criteria andBillcontactLessThanOrEqualTo(Integer value) {
            addCriterion("billcontact <=", value, "billcontact");
            return (Criteria) this;
        }

        public Criteria andBillcontactIn(List<Integer> values) {
            addCriterion("billcontact in", values, "billcontact");
            return (Criteria) this;
        }

        public Criteria andBillcontactNotIn(List<Integer> values) {
            addCriterion("billcontact not in", values, "billcontact");
            return (Criteria) this;
        }

        public Criteria andBillcontactBetween(Integer value1, Integer value2) {
            addCriterion("billcontact between", value1, value2, "billcontact");
            return (Criteria) this;
        }

        public Criteria andBillcontactNotBetween(Integer value1, Integer value2) {
            addCriterion("billcontact not between", value1, value2, "billcontact");
            return (Criteria) this;
        }

        public Criteria andShipaccountIsNull() {
            addCriterion("shipaccount is null");
            return (Criteria) this;
        }

        public Criteria andShipaccountIsNotNull() {
            addCriterion("shipaccount is not null");
            return (Criteria) this;
        }

        public Criteria andShipaccountEqualTo(Integer value) {
            addCriterion("shipaccount =", value, "shipaccount");
            return (Criteria) this;
        }

        public Criteria andShipaccountNotEqualTo(Integer value) {
            addCriterion("shipaccount <>", value, "shipaccount");
            return (Criteria) this;
        }

        public Criteria andShipaccountGreaterThan(Integer value) {
            addCriterion("shipaccount >", value, "shipaccount");
            return (Criteria) this;
        }

        public Criteria andShipaccountGreaterThanOrEqualTo(Integer value) {
            addCriterion("shipaccount >=", value, "shipaccount");
            return (Criteria) this;
        }

        public Criteria andShipaccountLessThan(Integer value) {
            addCriterion("shipaccount <", value, "shipaccount");
            return (Criteria) this;
        }

        public Criteria andShipaccountLessThanOrEqualTo(Integer value) {
            addCriterion("shipaccount <=", value, "shipaccount");
            return (Criteria) this;
        }

        public Criteria andShipaccountIn(List<Integer> values) {
            addCriterion("shipaccount in", values, "shipaccount");
            return (Criteria) this;
        }

        public Criteria andShipaccountNotIn(List<Integer> values) {
            addCriterion("shipaccount not in", values, "shipaccount");
            return (Criteria) this;
        }

        public Criteria andShipaccountBetween(Integer value1, Integer value2) {
            addCriterion("shipaccount between", value1, value2, "shipaccount");
            return (Criteria) this;
        }

        public Criteria andShipaccountNotBetween(Integer value1, Integer value2) {
            addCriterion("shipaccount not between", value1, value2, "shipaccount");
            return (Criteria) this;
        }

        public Criteria andShipcontactIsNull() {
            addCriterion("shipcontact is null");
            return (Criteria) this;
        }

        public Criteria andShipcontactIsNotNull() {
            addCriterion("shipcontact is not null");
            return (Criteria) this;
        }

        public Criteria andShipcontactEqualTo(Integer value) {
            addCriterion("shipcontact =", value, "shipcontact");
            return (Criteria) this;
        }

        public Criteria andShipcontactNotEqualTo(Integer value) {
            addCriterion("shipcontact <>", value, "shipcontact");
            return (Criteria) this;
        }

        public Criteria andShipcontactGreaterThan(Integer value) {
            addCriterion("shipcontact >", value, "shipcontact");
            return (Criteria) this;
        }

        public Criteria andShipcontactGreaterThanOrEqualTo(Integer value) {
            addCriterion("shipcontact >=", value, "shipcontact");
            return (Criteria) this;
        }

        public Criteria andShipcontactLessThan(Integer value) {
            addCriterion("shipcontact <", value, "shipcontact");
            return (Criteria) this;
        }

        public Criteria andShipcontactLessThanOrEqualTo(Integer value) {
            addCriterion("shipcontact <=", value, "shipcontact");
            return (Criteria) this;
        }

        public Criteria andShipcontactIn(List<Integer> values) {
            addCriterion("shipcontact in", values, "shipcontact");
            return (Criteria) this;
        }

        public Criteria andShipcontactNotIn(List<Integer> values) {
            addCriterion("shipcontact not in", values, "shipcontact");
            return (Criteria) this;
        }

        public Criteria andShipcontactBetween(Integer value1, Integer value2) {
            addCriterion("shipcontact between", value1, value2, "shipcontact");
            return (Criteria) this;
        }

        public Criteria andShipcontactNotBetween(Integer value1, Integer value2) {
            addCriterion("shipcontact not between", value1, value2, "shipcontact");
            return (Criteria) this;
        }

        public Criteria andBillingaddressIsNull() {
            addCriterion("billingaddress is null");
            return (Criteria) this;
        }

        public Criteria andBillingaddressIsNotNull() {
            addCriterion("billingaddress is not null");
            return (Criteria) this;
        }

        public Criteria andBillingaddressEqualTo(String value) {
            addCriterion("billingaddress =", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressNotEqualTo(String value) {
            addCriterion("billingaddress <>", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressGreaterThan(String value) {
            addCriterion("billingaddress >", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressGreaterThanOrEqualTo(String value) {
            addCriterion("billingaddress >=", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressLessThan(String value) {
            addCriterion("billingaddress <", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressLessThanOrEqualTo(String value) {
            addCriterion("billingaddress <=", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressLike(String value) {
            addCriterion("billingaddress like", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressNotLike(String value) {
            addCriterion("billingaddress not like", value, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressIn(List<String> values) {
            addCriterion("billingaddress in", values, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressNotIn(List<String> values) {
            addCriterion("billingaddress not in", values, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressBetween(String value1, String value2) {
            addCriterion("billingaddress between", value1, value2, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingaddressNotBetween(String value1, String value2) {
            addCriterion("billingaddress not between", value1, value2, "billingaddress");
            return (Criteria) this;
        }

        public Criteria andBillingcityIsNull() {
            addCriterion("billingcity is null");
            return (Criteria) this;
        }

        public Criteria andBillingcityIsNotNull() {
            addCriterion("billingcity is not null");
            return (Criteria) this;
        }

        public Criteria andBillingcityEqualTo(String value) {
            addCriterion("billingcity =", value, "billingcity");
            return (Criteria) this;
        }

        public Criteria andBillingcityNotEqualTo(String value) {
            addCriterion("billingcity <>", value, "billingcity");
            return (Criteria) this;
        }

        public Criteria andBillingcityGreaterThan(String value) {
            addCriterion("billingcity >", value, "billingcity");
            return (Criteria) this;
        }

        public Criteria andBillingcityGreaterThanOrEqualTo(String value) {
            addCriterion("billingcity >=", value, "billingcity");
            return (Criteria) this;
        }

        public Criteria andBillingcityLessThan(String value) {
            addCriterion("billingcity <", value, "billingcity");
            return (Criteria) this;
        }

        public Criteria andBillingcityLessThanOrEqualTo(String value) {
            addCriterion("billingcity <=", value, "billingcity");
            return (Criteria) this;
        }

        public Criteria andBillingcityLike(String value) {
            addCriterion("billingcity like", value, "billingcity");
            return (Criteria) this;
        }

        public Criteria andBillingcityNotLike(String value) {
            addCriterion("billingcity not like", value, "billingcity");
            return (Criteria) this;
        }

        public Criteria andBillingcityIn(List<String> values) {
            addCriterion("billingcity in", values, "billingcity");
            return (Criteria) this;
        }

        public Criteria andBillingcityNotIn(List<String> values) {
            addCriterion("billingcity not in", values, "billingcity");
            return (Criteria) this;
        }

        public Criteria andBillingcityBetween(String value1, String value2) {
            addCriterion("billingcity between", value1, value2, "billingcity");
            return (Criteria) this;
        }

        public Criteria andBillingcityNotBetween(String value1, String value2) {
            addCriterion("billingcity not between", value1, value2, "billingcity");
            return (Criteria) this;
        }

        public Criteria andBillingstateIsNull() {
            addCriterion("billingstate is null");
            return (Criteria) this;
        }

        public Criteria andBillingstateIsNotNull() {
            addCriterion("billingstate is not null");
            return (Criteria) this;
        }

        public Criteria andBillingstateEqualTo(String value) {
            addCriterion("billingstate =", value, "billingstate");
            return (Criteria) this;
        }

        public Criteria andBillingstateNotEqualTo(String value) {
            addCriterion("billingstate <>", value, "billingstate");
            return (Criteria) this;
        }

        public Criteria andBillingstateGreaterThan(String value) {
            addCriterion("billingstate >", value, "billingstate");
            return (Criteria) this;
        }

        public Criteria andBillingstateGreaterThanOrEqualTo(String value) {
            addCriterion("billingstate >=", value, "billingstate");
            return (Criteria) this;
        }

        public Criteria andBillingstateLessThan(String value) {
            addCriterion("billingstate <", value, "billingstate");
            return (Criteria) this;
        }

        public Criteria andBillingstateLessThanOrEqualTo(String value) {
            addCriterion("billingstate <=", value, "billingstate");
            return (Criteria) this;
        }

        public Criteria andBillingstateLike(String value) {
            addCriterion("billingstate like", value, "billingstate");
            return (Criteria) this;
        }

        public Criteria andBillingstateNotLike(String value) {
            addCriterion("billingstate not like", value, "billingstate");
            return (Criteria) this;
        }

        public Criteria andBillingstateIn(List<String> values) {
            addCriterion("billingstate in", values, "billingstate");
            return (Criteria) this;
        }

        public Criteria andBillingstateNotIn(List<String> values) {
            addCriterion("billingstate not in", values, "billingstate");
            return (Criteria) this;
        }

        public Criteria andBillingstateBetween(String value1, String value2) {
            addCriterion("billingstate between", value1, value2, "billingstate");
            return (Criteria) this;
        }

        public Criteria andBillingstateNotBetween(String value1, String value2) {
            addCriterion("billingstate not between", value1, value2, "billingstate");
            return (Criteria) this;
        }

        public Criteria andBillingpostalcodeIsNull() {
            addCriterion("billingpostalcode is null");
            return (Criteria) this;
        }

        public Criteria andBillingpostalcodeIsNotNull() {
            addCriterion("billingpostalcode is not null");
            return (Criteria) this;
        }

        public Criteria andBillingpostalcodeEqualTo(String value) {
            addCriterion("billingpostalcode =", value, "billingpostalcode");
            return (Criteria) this;
        }

        public Criteria andBillingpostalcodeNotEqualTo(String value) {
            addCriterion("billingpostalcode <>", value, "billingpostalcode");
            return (Criteria) this;
        }

        public Criteria andBillingpostalcodeGreaterThan(String value) {
            addCriterion("billingpostalcode >", value, "billingpostalcode");
            return (Criteria) this;
        }

        public Criteria andBillingpostalcodeGreaterThanOrEqualTo(String value) {
            addCriterion("billingpostalcode >=", value, "billingpostalcode");
            return (Criteria) this;
        }

        public Criteria andBillingpostalcodeLessThan(String value) {
            addCriterion("billingpostalcode <", value, "billingpostalcode");
            return (Criteria) this;
        }

        public Criteria andBillingpostalcodeLessThanOrEqualTo(String value) {
            addCriterion("billingpostalcode <=", value, "billingpostalcode");
            return (Criteria) this;
        }

        public Criteria andBillingpostalcodeLike(String value) {
            addCriterion("billingpostalcode like", value, "billingpostalcode");
            return (Criteria) this;
        }

        public Criteria andBillingpostalcodeNotLike(String value) {
            addCriterion("billingpostalcode not like", value, "billingpostalcode");
            return (Criteria) this;
        }

        public Criteria andBillingpostalcodeIn(List<String> values) {
            addCriterion("billingpostalcode in", values, "billingpostalcode");
            return (Criteria) this;
        }

        public Criteria andBillingpostalcodeNotIn(List<String> values) {
            addCriterion("billingpostalcode not in", values, "billingpostalcode");
            return (Criteria) this;
        }

        public Criteria andBillingpostalcodeBetween(String value1, String value2) {
            addCriterion("billingpostalcode between", value1, value2, "billingpostalcode");
            return (Criteria) this;
        }

        public Criteria andBillingpostalcodeNotBetween(String value1, String value2) {
            addCriterion("billingpostalcode not between", value1, value2, "billingpostalcode");
            return (Criteria) this;
        }

        public Criteria andBillingcountryIsNull() {
            addCriterion("billingcountry is null");
            return (Criteria) this;
        }

        public Criteria andBillingcountryIsNotNull() {
            addCriterion("billingcountry is not null");
            return (Criteria) this;
        }

        public Criteria andBillingcountryEqualTo(String value) {
            addCriterion("billingcountry =", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryNotEqualTo(String value) {
            addCriterion("billingcountry <>", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryGreaterThan(String value) {
            addCriterion("billingcountry >", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryGreaterThanOrEqualTo(String value) {
            addCriterion("billingcountry >=", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryLessThan(String value) {
            addCriterion("billingcountry <", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryLessThanOrEqualTo(String value) {
            addCriterion("billingcountry <=", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryLike(String value) {
            addCriterion("billingcountry like", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryNotLike(String value) {
            addCriterion("billingcountry not like", value, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryIn(List<String> values) {
            addCriterion("billingcountry in", values, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryNotIn(List<String> values) {
            addCriterion("billingcountry not in", values, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryBetween(String value1, String value2) {
            addCriterion("billingcountry between", value1, value2, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andBillingcountryNotBetween(String value1, String value2) {
            addCriterion("billingcountry not between", value1, value2, "billingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingaddressIsNull() {
            addCriterion("shippingaddress is null");
            return (Criteria) this;
        }

        public Criteria andShippingaddressIsNotNull() {
            addCriterion("shippingaddress is not null");
            return (Criteria) this;
        }

        public Criteria andShippingaddressEqualTo(String value) {
            addCriterion("shippingaddress =", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressNotEqualTo(String value) {
            addCriterion("shippingaddress <>", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressGreaterThan(String value) {
            addCriterion("shippingaddress >", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressGreaterThanOrEqualTo(String value) {
            addCriterion("shippingaddress >=", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressLessThan(String value) {
            addCriterion("shippingaddress <", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressLessThanOrEqualTo(String value) {
            addCriterion("shippingaddress <=", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressLike(String value) {
            addCriterion("shippingaddress like", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressNotLike(String value) {
            addCriterion("shippingaddress not like", value, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressIn(List<String> values) {
            addCriterion("shippingaddress in", values, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressNotIn(List<String> values) {
            addCriterion("shippingaddress not in", values, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressBetween(String value1, String value2) {
            addCriterion("shippingaddress between", value1, value2, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingaddressNotBetween(String value1, String value2) {
            addCriterion("shippingaddress not between", value1, value2, "shippingaddress");
            return (Criteria) this;
        }

        public Criteria andShippingcityIsNull() {
            addCriterion("shippingcity is null");
            return (Criteria) this;
        }

        public Criteria andShippingcityIsNotNull() {
            addCriterion("shippingcity is not null");
            return (Criteria) this;
        }

        public Criteria andShippingcityEqualTo(String value) {
            addCriterion("shippingcity =", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityNotEqualTo(String value) {
            addCriterion("shippingcity <>", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityGreaterThan(String value) {
            addCriterion("shippingcity >", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityGreaterThanOrEqualTo(String value) {
            addCriterion("shippingcity >=", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityLessThan(String value) {
            addCriterion("shippingcity <", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityLessThanOrEqualTo(String value) {
            addCriterion("shippingcity <=", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityLike(String value) {
            addCriterion("shippingcity like", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityNotLike(String value) {
            addCriterion("shippingcity not like", value, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityIn(List<String> values) {
            addCriterion("shippingcity in", values, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityNotIn(List<String> values) {
            addCriterion("shippingcity not in", values, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityBetween(String value1, String value2) {
            addCriterion("shippingcity between", value1, value2, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingcityNotBetween(String value1, String value2) {
            addCriterion("shippingcity not between", value1, value2, "shippingcity");
            return (Criteria) this;
        }

        public Criteria andShippingstateIsNull() {
            addCriterion("shippingstate is null");
            return (Criteria) this;
        }

        public Criteria andShippingstateIsNotNull() {
            addCriterion("shippingstate is not null");
            return (Criteria) this;
        }

        public Criteria andShippingstateEqualTo(String value) {
            addCriterion("shippingstate =", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateNotEqualTo(String value) {
            addCriterion("shippingstate <>", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateGreaterThan(String value) {
            addCriterion("shippingstate >", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateGreaterThanOrEqualTo(String value) {
            addCriterion("shippingstate >=", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateLessThan(String value) {
            addCriterion("shippingstate <", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateLessThanOrEqualTo(String value) {
            addCriterion("shippingstate <=", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateLike(String value) {
            addCriterion("shippingstate like", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateNotLike(String value) {
            addCriterion("shippingstate not like", value, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateIn(List<String> values) {
            addCriterion("shippingstate in", values, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateNotIn(List<String> values) {
            addCriterion("shippingstate not in", values, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateBetween(String value1, String value2) {
            addCriterion("shippingstate between", value1, value2, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingstateNotBetween(String value1, String value2) {
            addCriterion("shippingstate not between", value1, value2, "shippingstate");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeIsNull() {
            addCriterion("shippingpostalcode is null");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeIsNotNull() {
            addCriterion("shippingpostalcode is not null");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeEqualTo(String value) {
            addCriterion("shippingpostalcode =", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeNotEqualTo(String value) {
            addCriterion("shippingpostalcode <>", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeGreaterThan(String value) {
            addCriterion("shippingpostalcode >", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeGreaterThanOrEqualTo(String value) {
            addCriterion("shippingpostalcode >=", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeLessThan(String value) {
            addCriterion("shippingpostalcode <", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeLessThanOrEqualTo(String value) {
            addCriterion("shippingpostalcode <=", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeLike(String value) {
            addCriterion("shippingpostalcode like", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeNotLike(String value) {
            addCriterion("shippingpostalcode not like", value, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeIn(List<String> values) {
            addCriterion("shippingpostalcode in", values, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeNotIn(List<String> values) {
            addCriterion("shippingpostalcode not in", values, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeBetween(String value1, String value2) {
            addCriterion("shippingpostalcode between", value1, value2, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingpostalcodeNotBetween(String value1, String value2) {
            addCriterion("shippingpostalcode not between", value1, value2, "shippingpostalcode");
            return (Criteria) this;
        }

        public Criteria andShippingcountryIsNull() {
            addCriterion("shippingcountry is null");
            return (Criteria) this;
        }

        public Criteria andShippingcountryIsNotNull() {
            addCriterion("shippingcountry is not null");
            return (Criteria) this;
        }

        public Criteria andShippingcountryEqualTo(String value) {
            addCriterion("shippingcountry =", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryNotEqualTo(String value) {
            addCriterion("shippingcountry <>", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryGreaterThan(String value) {
            addCriterion("shippingcountry >", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryGreaterThanOrEqualTo(String value) {
            addCriterion("shippingcountry >=", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryLessThan(String value) {
            addCriterion("shippingcountry <", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryLessThanOrEqualTo(String value) {
            addCriterion("shippingcountry <=", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryLike(String value) {
            addCriterion("shippingcountry like", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryNotLike(String value) {
            addCriterion("shippingcountry not like", value, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryIn(List<String> values) {
            addCriterion("shippingcountry in", values, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryNotIn(List<String> values) {
            addCriterion("shippingcountry not in", values, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryBetween(String value1, String value2) {
            addCriterion("shippingcountry between", value1, value2, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andShippingcountryNotBetween(String value1, String value2) {
            addCriterion("shippingcountry not between", value1, value2, "shippingcountry");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNull() {
            addCriterion("description is null");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNotNull() {
            addCriterion("description is not null");
            return (Criteria) this;
        }

        public Criteria andDescriptionEqualTo(String value) {
            addCriterion("description =", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotEqualTo(String value) {
            addCriterion("description <>", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThan(String value) {
            addCriterion("description >", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("description >=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThan(String value) {
            addCriterion("description <", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThanOrEqualTo(String value) {
            addCriterion("description <=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLike(String value) {
            addCriterion("description like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotLike(String value) {
            addCriterion("description not like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionIn(List<String> values) {
            addCriterion("description in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotIn(List<String> values) {
            addCriterion("description not in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionBetween(String value1, String value2) {
            addCriterion("description between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotBetween(String value1, String value2) {
            addCriterion("description not between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andPaymenttermIsNull() {
            addCriterion("paymentterm is null");
            return (Criteria) this;
        }

        public Criteria andPaymenttermIsNotNull() {
            addCriterion("paymentterm is not null");
            return (Criteria) this;
        }

        public Criteria andPaymenttermEqualTo(String value) {
            addCriterion("paymentterm =", value, "paymentterm");
            return (Criteria) this;
        }

        public Criteria andPaymenttermNotEqualTo(String value) {
            addCriterion("paymentterm <>", value, "paymentterm");
            return (Criteria) this;
        }

        public Criteria andPaymenttermGreaterThan(String value) {
            addCriterion("paymentterm >", value, "paymentterm");
            return (Criteria) this;
        }

        public Criteria andPaymenttermGreaterThanOrEqualTo(String value) {
            addCriterion("paymentterm >=", value, "paymentterm");
            return (Criteria) this;
        }

        public Criteria andPaymenttermLessThan(String value) {
            addCriterion("paymentterm <", value, "paymentterm");
            return (Criteria) this;
        }

        public Criteria andPaymenttermLessThanOrEqualTo(String value) {
            addCriterion("paymentterm <=", value, "paymentterm");
            return (Criteria) this;
        }

        public Criteria andPaymenttermLike(String value) {
            addCriterion("paymentterm like", value, "paymentterm");
            return (Criteria) this;
        }

        public Criteria andPaymenttermNotLike(String value) {
            addCriterion("paymentterm not like", value, "paymentterm");
            return (Criteria) this;
        }

        public Criteria andPaymenttermIn(List<String> values) {
            addCriterion("paymentterm in", values, "paymentterm");
            return (Criteria) this;
        }

        public Criteria andPaymenttermNotIn(List<String> values) {
            addCriterion("paymentterm not in", values, "paymentterm");
            return (Criteria) this;
        }

        public Criteria andPaymenttermBetween(String value1, String value2) {
            addCriterion("paymentterm between", value1, value2, "paymentterm");
            return (Criteria) this;
        }

        public Criteria andPaymenttermNotBetween(String value1, String value2) {
            addCriterion("paymentterm not between", value1, value2, "paymentterm");
            return (Criteria) this;
        }

        public Criteria andOriginalpodateIsNull() {
            addCriterion("originalpodate is null");
            return (Criteria) this;
        }

        public Criteria andOriginalpodateIsNotNull() {
            addCriterion("originalpodate is not null");
            return (Criteria) this;
        }

        public Criteria andOriginalpodateEqualTo(Date value) {
            addCriterion("originalpodate =", value, "originalpodate");
            return (Criteria) this;
        }

        public Criteria andOriginalpodateNotEqualTo(Date value) {
            addCriterion("originalpodate <>", value, "originalpodate");
            return (Criteria) this;
        }

        public Criteria andOriginalpodateGreaterThan(Date value) {
            addCriterion("originalpodate >", value, "originalpodate");
            return (Criteria) this;
        }

        public Criteria andOriginalpodateGreaterThanOrEqualTo(Date value) {
            addCriterion("originalpodate >=", value, "originalpodate");
            return (Criteria) this;
        }

        public Criteria andOriginalpodateLessThan(Date value) {
            addCriterion("originalpodate <", value, "originalpodate");
            return (Criteria) this;
        }

        public Criteria andOriginalpodateLessThanOrEqualTo(Date value) {
            addCriterion("originalpodate <=", value, "originalpodate");
            return (Criteria) this;
        }

        public Criteria andOriginalpodateIn(List<Date> values) {
            addCriterion("originalpodate in", values, "originalpodate");
            return (Criteria) this;
        }

        public Criteria andOriginalpodateNotIn(List<Date> values) {
            addCriterion("originalpodate not in", values, "originalpodate");
            return (Criteria) this;
        }

        public Criteria andOriginalpodateBetween(Date value1, Date value2) {
            addCriterion("originalpodate between", value1, value2, "originalpodate");
            return (Criteria) this;
        }

        public Criteria andOriginalpodateNotBetween(Date value1, Date value2) {
            addCriterion("originalpodate not between", value1, value2, "originalpodate");
            return (Criteria) this;
        }

        public Criteria andPurchaseordernumIsNull() {
            addCriterion("purchaseordernum is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseordernumIsNotNull() {
            addCriterion("purchaseordernum is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseordernumEqualTo(String value) {
            addCriterion("purchaseordernum =", value, "purchaseordernum");
            return (Criteria) this;
        }

        public Criteria andPurchaseordernumNotEqualTo(String value) {
            addCriterion("purchaseordernum <>", value, "purchaseordernum");
            return (Criteria) this;
        }

        public Criteria andPurchaseordernumGreaterThan(String value) {
            addCriterion("purchaseordernum >", value, "purchaseordernum");
            return (Criteria) this;
        }

        public Criteria andPurchaseordernumGreaterThanOrEqualTo(String value) {
            addCriterion("purchaseordernum >=", value, "purchaseordernum");
            return (Criteria) this;
        }

        public Criteria andPurchaseordernumLessThan(String value) {
            addCriterion("purchaseordernum <", value, "purchaseordernum");
            return (Criteria) this;
        }

        public Criteria andPurchaseordernumLessThanOrEqualTo(String value) {
            addCriterion("purchaseordernum <=", value, "purchaseordernum");
            return (Criteria) this;
        }

        public Criteria andPurchaseordernumLike(String value) {
            addCriterion("purchaseordernum like", value, "purchaseordernum");
            return (Criteria) this;
        }

        public Criteria andPurchaseordernumNotLike(String value) {
            addCriterion("purchaseordernum not like", value, "purchaseordernum");
            return (Criteria) this;
        }

        public Criteria andPurchaseordernumIn(List<String> values) {
            addCriterion("purchaseordernum in", values, "purchaseordernum");
            return (Criteria) this;
        }

        public Criteria andPurchaseordernumNotIn(List<String> values) {
            addCriterion("purchaseordernum not in", values, "purchaseordernum");
            return (Criteria) this;
        }

        public Criteria andPurchaseordernumBetween(String value1, String value2) {
            addCriterion("purchaseordernum between", value1, value2, "purchaseordernum");
            return (Criteria) this;
        }

        public Criteria andPurchaseordernumNotBetween(String value1, String value2) {
            addCriterion("purchaseordernum not between", value1, value2, "purchaseordernum");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeIsNull() {
            addCriterion("createdTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeIsNotNull() {
            addCriterion("createdTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeEqualTo(Date value) {
            addCriterion("createdTime =", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeNotEqualTo(Date value) {
            addCriterion("createdTime <>", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeGreaterThan(Date value) {
            addCriterion("createdTime >", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createdTime >=", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeLessThan(Date value) {
            addCriterion("createdTime <", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeLessThanOrEqualTo(Date value) {
            addCriterion("createdTime <=", value, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeIn(List<Date> values) {
            addCriterion("createdTime in", values, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeNotIn(List<Date> values) {
            addCriterion("createdTime not in", values, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeBetween(Date value1, Date value2) {
            addCriterion("createdTime between", value1, value2, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreatedtimeNotBetween(Date value1, Date value2) {
            addCriterion("createdTime not between", value1, value2, "createdtime");
            return (Criteria) this;
        }

        public Criteria andCreateduserIsNull() {
            addCriterion("createdUser is null");
            return (Criteria) this;
        }

        public Criteria andCreateduserIsNotNull() {
            addCriterion("createdUser is not null");
            return (Criteria) this;
        }

        public Criteria andCreateduserEqualTo(String value) {
            addCriterion("createdUser =", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotEqualTo(String value) {
            addCriterion("createdUser <>", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserGreaterThan(String value) {
            addCriterion("createdUser >", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserGreaterThanOrEqualTo(String value) {
            addCriterion("createdUser >=", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserLessThan(String value) {
            addCriterion("createdUser <", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserLessThanOrEqualTo(String value) {
            addCriterion("createdUser <=", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserLike(String value) {
            addCriterion("createdUser like", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotLike(String value) {
            addCriterion("createdUser not like", value, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserIn(List<String> values) {
            addCriterion("createdUser in", values, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotIn(List<String> values) {
            addCriterion("createdUser not in", values, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserBetween(String value1, String value2) {
            addCriterion("createdUser between", value1, value2, "createduser");
            return (Criteria) this;
        }

        public Criteria andCreateduserNotBetween(String value1, String value2) {
            addCriterion("createdUser not between", value1, value2, "createduser");
            return (Criteria) this;
        }

        public Criteria andSaccountidIsNull() {
            addCriterion("sAccountId is null");
            return (Criteria) this;
        }

        public Criteria andSaccountidIsNotNull() {
            addCriterion("sAccountId is not null");
            return (Criteria) this;
        }

        public Criteria andSaccountidEqualTo(Integer value) {
            addCriterion("sAccountId =", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidNotEqualTo(Integer value) {
            addCriterion("sAccountId <>", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidGreaterThan(Integer value) {
            addCriterion("sAccountId >", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidGreaterThanOrEqualTo(Integer value) {
            addCriterion("sAccountId >=", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidLessThan(Integer value) {
            addCriterion("sAccountId <", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidLessThanOrEqualTo(Integer value) {
            addCriterion("sAccountId <=", value, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidIn(List<Integer> values) {
            addCriterion("sAccountId in", values, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidNotIn(List<Integer> values) {
            addCriterion("sAccountId not in", values, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidBetween(Integer value1, Integer value2) {
            addCriterion("sAccountId between", value1, value2, "saccountid");
            return (Criteria) this;
        }

        public Criteria andSaccountidNotBetween(Integer value1, Integer value2) {
            addCriterion("sAccountId not between", value1, value2, "saccountid");
            return (Criteria) this;
        }

        public Criteria andAssignuserIsNull() {
            addCriterion("assignUser is null");
            return (Criteria) this;
        }

        public Criteria andAssignuserIsNotNull() {
            addCriterion("assignUser is not null");
            return (Criteria) this;
        }

        public Criteria andAssignuserEqualTo(String value) {
            addCriterion("assignUser =", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserNotEqualTo(String value) {
            addCriterion("assignUser <>", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserGreaterThan(String value) {
            addCriterion("assignUser >", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserGreaterThanOrEqualTo(String value) {
            addCriterion("assignUser >=", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserLessThan(String value) {
            addCriterion("assignUser <", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserLessThanOrEqualTo(String value) {
            addCriterion("assignUser <=", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserLike(String value) {
            addCriterion("assignUser like", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserNotLike(String value) {
            addCriterion("assignUser not like", value, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserIn(List<String> values) {
            addCriterion("assignUser in", values, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserNotIn(List<String> values) {
            addCriterion("assignUser not in", values, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserBetween(String value1, String value2) {
            addCriterion("assignUser between", value1, value2, "assignuser");
            return (Criteria) this;
        }

        public Criteria andAssignuserNotBetween(String value1, String value2) {
            addCriterion("assignUser not between", value1, value2, "assignuser");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeIsNull() {
            addCriterion("lastUpdatedTime is null");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeIsNotNull() {
            addCriterion("lastUpdatedTime is not null");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeEqualTo(Date value) {
            addCriterion("lastUpdatedTime =", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeNotEqualTo(Date value) {
            addCriterion("lastUpdatedTime <>", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeGreaterThan(Date value) {
            addCriterion("lastUpdatedTime >", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("lastUpdatedTime >=", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeLessThan(Date value) {
            addCriterion("lastUpdatedTime <", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeLessThanOrEqualTo(Date value) {
            addCriterion("lastUpdatedTime <=", value, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeIn(List<Date> values) {
            addCriterion("lastUpdatedTime in", values, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeNotIn(List<Date> values) {
            addCriterion("lastUpdatedTime not in", values, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeBetween(Date value1, Date value2) {
            addCriterion("lastUpdatedTime between", value1, value2, "lastupdatedtime");
            return (Criteria) this;
        }

        public Criteria andLastupdatedtimeNotBetween(Date value1, Date value2) {
            addCriterion("lastUpdatedTime not between", value1, value2, "lastupdatedtime");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table m_crm_quote
     *
     * @mbggenerated do_not_delete_during_merge Wed Mar 11 09:10:39 ICT 2015
     */
    @SuppressWarnings("ucd")
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table m_crm_quote
     *
     * @mbggenerated Wed Mar 11 09:10:39 ICT 2015
     */
    @SuppressWarnings("ucd")
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}